Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 87 |
| Missing cells | 78 |
| Missing cells (%) | 6.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 10.3 KiB |
| Average record size in memory | 121.5 B |
Variable types
| Numeric | 14 |
|---|---|
| Categorical | 1 |
Results is highly correlated with Reach and 3 other fields | High correlation |
Reach is highly correlated with Results and 5 other fields | High correlation |
Impressions is highly correlated with Results and 5 other fields | High correlation |
Cost per results is highly correlated with Results and 1 other fields | High correlation |
Amount spent (MXN) is highly correlated with Reach and 5 other fields | High correlation |
Result rate is highly correlated with Results and 1 other fields | High correlation |
New messaging connections is highly correlated with Reach and 3 other fields | High correlation |
Messaging Conversations Started is highly correlated with Reach and 3 other fields | High correlation |
Frequency is highly correlated with Reach and 2 other fields | High correlation |
CPC (All) (MXN) is highly correlated with Amount spent (MXN) | High correlation |
Results is highly correlated with Result rate | High correlation |
Reach is highly correlated with Impressions and 3 other fields | High correlation |
Impressions is highly correlated with Reach and 3 other fields | High correlation |
Amount spent (MXN) is highly correlated with Reach and 2 other fields | High correlation |
Result rate is highly correlated with Results | High correlation |
New messaging connections is highly correlated with Reach and 3 other fields | High correlation |
Messaging Conversations Started is highly correlated with Reach and 2 other fields | High correlation |
Results is highly correlated with Messaging Conversations Started | High correlation |
Reach is highly correlated with Impressions and 3 other fields | High correlation |
Impressions is highly correlated with Reach and 3 other fields | High correlation |
Cost per results is highly correlated with Result rate | High correlation |
Amount spent (MXN) is highly correlated with Reach and 4 other fields | High correlation |
Result rate is highly correlated with Cost per results | High correlation |
New messaging connections is highly correlated with Reach and 3 other fields | High correlation |
Messaging Conversations Started is highly correlated with Results and 4 other fields | High correlation |
Frequency is highly correlated with Amount spent (MXN) | High correlation |
Starts is highly correlated with Ends and 1 other fields | High correlation |
Ends is highly correlated with Starts | High correlation |
Ad set budget is highly correlated with Result rate and 3 other fields | High correlation |
Results is highly correlated with Reach and 2 other fields | High correlation |
Reach is highly correlated with Results and 5 other fields | High correlation |
Impressions is highly correlated with Results and 4 other fields | High correlation |
Cost per results is highly correlated with CPC (All) (MXN) | High correlation |
Amount spent (MXN) is highly correlated with Starts and 4 other fields | High correlation |
Result rate is highly correlated with Ad set budget and 2 other fields | High correlation |
New messaging connections is highly correlated with Reach and 3 other fields | High correlation |
Messaging Conversations Started is highly correlated with Ad set budget and 4 other fields | High correlation |
Frequency is highly correlated with Result rate | High correlation |
CPC (All) (MXN) is highly correlated with Ad set budget and 1 other fields | High correlation |
CTR (all) is highly correlated with Ad set budget and 1 other fields | High correlation |
Results has 12 (13.8%) missing values | Missing |
Cost per results has 12 (13.8%) missing values | Missing |
Result rate has 13 (14.9%) missing values | Missing |
New messaging connections has 23 (26.4%) missing values | Missing |
Messaging Conversations Started has 18 (20.7%) missing values | Missing |
Reach has 8 (9.2%) zeros | Zeros |
Impressions has 8 (9.2%) zeros | Zeros |
Cost per results has 1 (1.1%) zeros | Zeros |
Amount spent (MXN) has 8 (9.2%) zeros | Zeros |
Frequency has 8 (9.2%) zeros | Zeros |
CPC (All) (MXN) has 9 (10.3%) zeros | Zeros |
CTR (all) has 9 (10.3%) zeros | Zeros |
Reproduction
| Analysis started | 2022-04-20 02:39:42.627034 |
|---|---|
| Analysis finished | 2022-04-20 02:40:01.301588 |
| Duration | 18.67 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
Campaign ID
Real number (ℝ≥0)
| Distinct | 82 |
|---|---|
| Distinct (%) | 94.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 546.4022989 |
| Minimum | 121 |
|---|---|
| Maximum | 997 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 824.0 B |
Quantile statistics
| Minimum | 121 |
|---|---|
| 5-th percentile | 132.6 |
| Q1 | 289 |
| median | 544 |
| Q3 | 798.5 |
| 95-th percentile | 963.4 |
| Maximum | 997 |
| Range | 876 |
| Interquartile range (IQR) | 509.5 |
Descriptive statistics
| Standard deviation | 275.7441289 |
|---|---|
| Coefficient of variation (CV) | 0.5046540425 |
| Kurtosis | -1.252728351 |
| Mean | 546.4022989 |
| Median Absolute Deviation (MAD) | 262 |
| Skewness | 0.02785109742 |
| Sum | 47537 |
| Variance | 76034.82465 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 440 | 2 | 2.3% |
| 995 | 2 | 2.3% |
| 182 | 2 | 2.3% |
| 465 | 2 | 2.3% |
| 126 | 2 | 2.3% |
| 341 | 1 | 1.1% |
| 791 | 1 | 1.1% |
| 907 | 1 | 1.1% |
| 919 | 1 | 1.1% |
| 248 | 1 | 1.1% |
| Other values (72) | 72 |
| Value | Count | Frequency (%) |
| 121 | 1 | |
| 126 | 2 | |
| 127 | 1 | |
| 132 | 1 | |
| 134 | 1 | |
| 135 | 1 | |
| 144 | 1 | |
| 154 | 1 | |
| 175 | 1 | |
| 182 | 2 |
| Value | Count | Frequency (%) |
| 997 | 1 | |
| 995 | 2 | |
| 968 | 1 | |
| 964 | 1 | |
| 962 | 1 | |
| 956 | 1 | |
| 938 | 1 | |
| 928 | 1 | |
| 921 | 1 | |
| 919 | 1 |
| Distinct | 11 |
|---|---|
| Distinct (%) | 12.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.459770115 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 824.0 B |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 4.105596288 |
|---|---|
| Coefficient of variation (CV) | 0.7519723727 |
| Kurtosis | -1.45208762 |
| Mean | 5.459770115 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.4478453355 |
| Sum | 475 |
| Variance | 16.85592088 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 17 | |
| 2 | 15 | |
| 11 | 14 | |
| 3 | 11 | |
| 6 | 8 | |
| 12 | 7 | |
| 5 | 6 | 6.9% |
| 10 | 5 | 5.7% |
| 9 | 2 | 2.3% |
| 4 | 1 | 1.1% |
| Value | Count | Frequency (%) |
| 1 | 17 | |
| 2 | 15 | |
| 3 | 11 | |
| 4 | 1 | 1.1% |
| 5 | 6 | 6.9% |
| 6 | 8 | |
| 7 | 1 | 1.1% |
| 9 | 2 | 2.3% |
| 10 | 5 | 5.7% |
| 11 | 14 |
| Value | Count | Frequency (%) |
| 12 | 7 | |
| 11 | 14 | |
| 10 | 5 | 5.7% |
| 9 | 2 | 2.3% |
| 7 | 1 | 1.1% |
| 6 | 8 | |
| 5 | 6 | 6.9% |
| 4 | 1 | 1.1% |
| 3 | 11 | |
| 2 | 15 |
| Distinct | 10 |
|---|---|
| Distinct (%) | 11.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.701149425 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 824.0 B |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 3.997426331 |
|---|---|
| Coefficient of variation (CV) | 0.7011614733 |
| Kurtosis | -1.465909544 |
| Mean | 5.701149425 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.4431426903 |
| Sum | 496 |
| Variance | 15.97941727 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 20 | |
| 3 | 13 | |
| 11 | 13 | |
| 12 | 8 | 9.2% |
| 1 | 8 | 9.2% |
| 6 | 7 | 8.0% |
| 10 | 7 | 8.0% |
| 5 | 5 | 5.7% |
| 4 | 3 | 3.4% |
| 7 | 3 | 3.4% |
| Value | Count | Frequency (%) |
| 1 | 8 | 9.2% |
| 2 | 20 | |
| 3 | 13 | |
| 4 | 3 | 3.4% |
| 5 | 5 | 5.7% |
| 6 | 7 | 8.0% |
| 7 | 3 | 3.4% |
| 10 | 7 | 8.0% |
| 11 | 13 | |
| 12 | 8 | 9.2% |
| Value | Count | Frequency (%) |
| 12 | 8 | 9.2% |
| 11 | 13 | |
| 10 | 7 | 8.0% |
| 7 | 3 | 3.4% |
| 6 | 7 | 8.0% |
| 5 | 5 | 5.7% |
| 4 | 3 | 3.4% |
| 3 | 13 | |
| 2 | 20 | |
| 1 | 8 | 9.2% |
| Distinct | 21 |
|---|---|
| Distinct (%) | 24.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 824.0 B |
| Using ad set budget | |
|---|---|
| 500 | |
| 300 | |
| 1000 | |
| 200 | |
| Other values (16) |
Length
| Max length | 19 |
|---|---|
| Median length | 4 |
| Mean length | 8.540229885 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | 9.2% |
Sample
| 1st row | Using ad set budget |
|---|---|
| 2nd row | Using ad set budget |
| 3rd row | Using ad set budget |
| 4th row | Using ad set budget |
| 5th row | Using ad set budget |
Common Values
| Value | Count | Frequency (%) |
| Using ad set budget | 29 | |
| 500 | 10 | 11.5% |
| 300 | 10 | 11.5% |
| 1000 | 7 | 8.0% |
| 200 | 5 | 5.7% |
| 350 | 3 | 3.4% |
| 2000 | 3 | 3.4% |
| 1500 | 2 | 2.3% |
| 100 | 2 | 2.3% |
| 400 | 2 | 2.3% |
| Other values (11) | 14 |
Length
| Value | Count | Frequency (%) |
| using | 29 | |
| set | 29 | |
| budget | 29 | |
| ad | 29 | |
| 500 | 10 | 5.7% |
| 300 | 10 | 5.7% |
| 1000 | 7 | 4.0% |
| 200 | 5 | 2.9% |
| 350 | 3 | 1.7% |
| 2000 | 3 | 1.7% |
| Other values (14) | 20 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
Results
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 46 |
|---|---|
| Distinct (%) | 61.3% |
| Missing | 12 |
| Missing (%) | 13.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 387.76 |
| Minimum | 1 |
|---|---|
| Maximum | 16326 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 824.0 B |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 6 |
| median | 17 |
| Q3 | 43 |
| 95-th percentile | 1316.6 |
| Maximum | 16326 |
| Range | 16325 |
| Interquartile range (IQR) | 37 |
Descriptive statistics
| Standard deviation | 1944.376325 |
|---|---|
| Coefficient of variation (CV) | 5.014380867 |
| Kurtosis | 63.18845889 |
| Mean | 387.76 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 7.730455776 |
| Sum | 29082 |
| Variance | 3780599.293 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 5 | 5.7% |
| 3 | 4 | 4.6% |
| 10 | 4 | 4.6% |
| 8 | 4 | 4.6% |
| 5 | 3 | 3.4% |
| 2 | 3 | 3.4% |
| 9 | 3 | 3.4% |
| 6 | 3 | 3.4% |
| 17 | 3 | 3.4% |
| 43 | 2 | 2.3% |
| Other values (36) | 41 | |
| (Missing) | 12 | 13.8% |
| Value | Count | Frequency (%) |
| 1 | 5 | |
| 2 | 3 | |
| 3 | 4 | |
| 4 | 2 | 2.3% |
| 5 | 3 | |
| 6 | 3 | |
| 7 | 1 | 1.1% |
| 8 | 4 | |
| 9 | 3 | |
| 10 | 4 |
| Value | Count | Frequency (%) |
| 16326 | 1 | |
| 3757 | 1 | |
| 2263 | 1 | |
| 1661 | 1 | |
| 1169 | 1 | |
| 587 | 1 | |
| 505 | 1 | |
| 399 | 1 | |
| 295 | 1 | |
| 293 | 1 |
| Distinct | 80 |
|---|---|
| Distinct (%) | 92.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5641.367816 |
| Minimum | 0 |
|---|---|
| Maximum | 41768 |
| Zeros | 8 |
| Zeros (%) | 9.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 824.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1221 |
| median | 3657 |
| Q3 | 7639.5 |
| 95-th percentile | 17733.5 |
| Maximum | 41768 |
| Range | 41768 |
| Interquartile range (IQR) | 6418.5 |
Descriptive statistics
| Standard deviation | 6796.188388 |
|---|---|
| Coefficient of variation (CV) | 1.204705775 |
| Kurtosis | 9.236924449 |
| Mean | 5641.367816 |
| Median Absolute Deviation (MAD) | 2794 |
| Skewness | 2.557660414 |
| Sum | 490799 |
| Variance | 46188176.61 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 8 | 9.2% |
| 2511 | 1 | 1.1% |
| 5276 | 1 | 1.1% |
| 2048 | 1 | 1.1% |
| 4081 | 1 | 1.1% |
| 1402 | 1 | 1.1% |
| 2218 | 1 | 1.1% |
| 8417 | 1 | 1.1% |
| 4285 | 1 | 1.1% |
| 42 | 1 | 1.1% |
| Other values (70) | 70 |
| Value | Count | Frequency (%) |
| 0 | 8 | |
| 42 | 1 | 1.1% |
| 191 | 1 | 1.1% |
| 395 | 1 | 1.1% |
| 523 | 1 | 1.1% |
| 540 | 1 | 1.1% |
| 620 | 1 | 1.1% |
| 689 | 1 | 1.1% |
| 700 | 1 | 1.1% |
| 725 | 1 | 1.1% |
| Value | Count | Frequency (%) |
| 41768 | 1 | |
| 25664 | 1 | |
| 23776 | 1 | |
| 20564 | 1 | |
| 17804 | 1 | |
| 17569 | 1 | |
| 14376 | 1 | |
| 13750 | 1 | |
| 13536 | 1 | |
| 13358 | 1 |
Impressions
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 80 |
|---|---|
| Distinct (%) | 92.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7472.931034 |
| Minimum | 0 |
|---|---|
| Maximum | 55206 |
| Zeros | 8 |
| Zeros (%) | 9.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 824.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1514 |
| median | 4527 |
| Q3 | 9533 |
| 95-th percentile | 24923.9 |
| Maximum | 55206 |
| Range | 55206 |
| Interquartile range (IQR) | 8019 |
Descriptive statistics
| Standard deviation | 9174.974191 |
|---|---|
| Coefficient of variation (CV) | 1.227761122 |
| Kurtosis | 8.367787355 |
| Mean | 7472.931034 |
| Median Absolute Deviation (MAD) | 3650 |
| Skewness | 2.472016888 |
| Sum | 650145 |
| Variance | 84180151.41 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 8 | 9.2% |
| 3072 | 1 | 1.1% |
| 8177 | 1 | 1.1% |
| 2902 | 1 | 1.1% |
| 5283 | 1 | 1.1% |
| 1537 | 1 | 1.1% |
| 2825 | 1 | 1.1% |
| 9937 | 1 | 1.1% |
| 6092 | 1 | 1.1% |
| 42 | 1 | 1.1% |
| Other values (70) | 70 |
| Value | Count | Frequency (%) |
| 0 | 8 | |
| 42 | 1 | 1.1% |
| 196 | 1 | 1.1% |
| 395 | 1 | 1.1% |
| 538 | 1 | 1.1% |
| 634 | 1 | 1.1% |
| 661 | 1 | 1.1% |
| 715 | 1 | 1.1% |
| 749 | 1 | 1.1% |
| 993 | 1 | 1.1% |
| Value | Count | Frequency (%) |
| 55206 | 1 | |
| 34067 | 1 | |
| 29535 | 1 | |
| 28250 | 1 | |
| 25364 | 1 | |
| 23897 | 1 | |
| 22806 | 1 | |
| 22243 | 1 | |
| 20019 | 1 | |
| 17851 | 1 |
| Distinct | 74 |
|---|---|
| Distinct (%) | 98.7% |
| Missing | 12 |
| Missing (%) | 13.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.16460531 |
| Minimum | 0 |
|---|---|
| Maximum | 118.1957143 |
| Zeros | 1 |
| Zeros (%) | 1.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 824.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.0784661873 |
| Q1 | 4.718406593 |
| median | 11.62790698 |
| Q3 | 22.93363636 |
| 95-th percentile | 59.94883333 |
| Maximum | 118.1957143 |
| Range | 118.1957143 |
| Interquartile range (IQR) | 18.21522977 |
Descriptive statistics
| Standard deviation | 19.57396203 |
|---|---|
| Coefficient of variation (CV) | 1.140367732 |
| Kurtosis | 9.672232912 |
| Mean | 17.16460531 |
| Median Absolute Deviation (MAD) | 8.686730509 |
| Skewness | 2.634775576 |
| Sum | 1287.345398 |
| Variance | 383.1399896 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16.66666667 | 2 | 2.3% |
| 10.5025 | 1 | 1.1% |
| 18.86875 | 1 | 1.1% |
| 69.772 | 1 | 1.1% |
| 3.125 | 1 | 1.1% |
| 1.57 | 1 | 1.1% |
| 6.302 | 1 | 1.1% |
| 0.372344322 | 1 | 1.1% |
| 8.8 | 1 | 1.1% |
| 24.44444444 | 1 | 1.1% |
| Other values (64) | 64 | |
| (Missing) | 12 | 13.8% |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 0.043549488 | 1 | |
| 0.049604925 | 1 | |
| 0.06195316 | 1 | |
| 0.085543199 | 1 | |
| 0.086252129 | 1 | |
| 0.092454086 | 1 | |
| 0.177405941 | 1 | |
| 0.200084287 | 1 | |
| 0.338983051 | 1 |
| Value | Count | Frequency (%) |
| 118.1957143 | 1 | |
| 69.772 | 1 | |
| 66.7725 | 1 | |
| 65.55 | 1 | |
| 57.54833333 | 1 | |
| 39.04352941 | 1 | |
| 38.3975 | 1 | |
| 34.317 | 1 | |
| 32.02 | 1 | |
| 31.95 | 1 |
Amount spent (MXN)
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 70 |
|---|---|
| Distinct (%) | 80.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 232.6009195 |
| Minimum | 0 |
|---|---|
| Maximum | 1000 |
| Zeros | 8 |
| Zeros (%) | 9.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 824.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 48.455 |
| median | 145.29 |
| Q3 | 348.105 |
| 95-th percentile | 786.208 |
| Maximum | 1000 |
| Range | 1000 |
| Interquartile range (IQR) | 299.65 |
Descriptive statistics
| Standard deviation | 242.1726101 |
|---|---|
| Coefficient of variation (CV) | 1.041150699 |
| Kurtosis | 1.009047938 |
| Mean | 232.6009195 |
| Median Absolute Deviation (MAD) | 122.33 |
| Skewness | 1.284634332 |
| Sum | 20236.28 |
| Variance | 58647.57307 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 8 | 9.2% |
| 500 | 6 | 6.9% |
| 100 | 4 | 4.6% |
| 140.2 | 2 | 2.3% |
| 380 | 2 | 2.3% |
| 332.34 | 1 | 1.1% |
| 270 | 1 | 1.1% |
| 59.03 | 1 | 1.1% |
| 17.6 | 1 | 1.1% |
| 168.04 | 1 | 1.1% |
| Other values (60) | 60 |
| Value | Count | Frequency (%) |
| 0 | 8 | |
| 1.57 | 1 | 1.1% |
| 10.75 | 1 | 1.1% |
| 12.76 | 1 | 1.1% |
| 16.57 | 1 | 1.1% |
| 17.6 | 1 | 1.1% |
| 23.14 | 1 | 1.1% |
| 26.49 | 1 | 1.1% |
| 31.51 | 1 | 1.1% |
| 31.95 | 1 | 1.1% |
| Value | Count | Frequency (%) |
| 1000 | 1 | 1.1% |
| 887.41 | 1 | 1.1% |
| 827.37 | 1 | 1.1% |
| 809.85 | 1 | 1.1% |
| 787.3 | 1 | 1.1% |
| 783.66 | 1 | 1.1% |
| 663.74 | 1 | 1.1% |
| 633.2 | 1 | 1.1% |
| 607.57 | 1 | 1.1% |
| 500 | 6 |
Result rate
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 74 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 13 |
| Missing (%) | 14.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.137558289 |
| Minimum | 0.035078488 |
|---|---|
| Maximum | 74.17721519 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 824.0 B |
Quantile statistics
| Minimum | 0.035078488 |
|---|---|
| 5-th percentile | 0.081628135 |
| Q1 | 0.1515175448 |
| median | 0.274435813 |
| Q3 | 0.5872112327 |
| 95-th percentile | 11.64044754 |
| Maximum | 74.17721519 |
| Range | 74.1421367 |
| Interquartile range (IQR) | 0.435693688 |
Descriptive statistics
| Standard deviation | 13.99209232 |
|---|---|
| Coefficient of variation (CV) | 3.381726936 |
| Kurtosis | 19.59746779 |
| Mean | 4.137558289 |
| Median Absolute Deviation (MAD) | 0.1382532515 |
| Skewness | 4.495280686 |
| Sum | 306.1793134 |
| Variance | 195.7786474 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.137835975 | 1 | 1.1% |
| 0.130123617 | 1 | 1.1% |
| 0.283185841 | 1 | 1.1% |
| 0.050316997 | 1 | 1.1% |
| 1.050558109 | 1 | 1.1% |
| 2.380952381 | 1 | 1.1% |
| 0.31075202 | 1 | 1.1% |
| 5.229885057 | 1 | 1.1% |
| 0.230083405 | 1 | 1.1% |
| 0.267022697 | 1 | 1.1% |
| Other values (64) | 64 | |
| (Missing) | 13 | 14.9% |
| Value | Count | Frequency (%) |
| 0.035078488 | 1 | |
| 0.050316997 | 1 | |
| 0.063492063 | 1 | |
| 0.068386088 | 1 | |
| 0.088758468 | 1 | |
| 0.092947601 | 1 | |
| 0.096153846 | 1 | |
| 0.110448421 | 1 | |
| 0.111028868 | 1 | |
| 0.114890854 | 1 |
| Value | Count | Frequency (%) |
| 74.17721519 | 1 | |
| 71.58642463 | 1 | |
| 65.06612996 | 1 | |
| 12.77735272 | 1 | |
| 11.02826783 | 1 | |
| 11.01093802 | 1 | |
| 9.509152762 | 1 | |
| 7.460481607 | 1 | |
| 7.1863581 | 1 | |
| 5.229885057 | 1 |
New messaging connections
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 27 |
|---|---|
| Distinct (%) | 42.2% |
| Missing | 23 |
| Missing (%) | 26.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.046875 |
| Minimum | 1 |
|---|---|
| Maximum | 116 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 824.0 B |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 8 |
| Q3 | 22.25 |
| 95-th percentile | 40 |
| Maximum | 116 |
| Range | 115 |
| Interquartile range (IQR) | 19.25 |
Descriptive statistics
| Standard deviation | 18.55017194 |
|---|---|
| Coefficient of variation (CV) | 1.232825549 |
| Kurtosis | 12.9834101 |
| Mean | 15.046875 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.938898062 |
| Sum | 963 |
| Variance | 344.108879 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 8 | 9.2% |
| 3 | 6 | 6.9% |
| 2 | 6 | 6.9% |
| 6 | 4 | 4.6% |
| 9 | 3 | 3.4% |
| 8 | 3 | 3.4% |
| 10 | 3 | 3.4% |
| 7 | 3 | 3.4% |
| 40 | 3 | 3.4% |
| 26 | 3 | 3.4% |
| Other values (17) | 22 | |
| (Missing) | 23 |
| Value | Count | Frequency (%) |
| 1 | 8 | |
| 2 | 6 | |
| 3 | 6 | |
| 4 | 2 | 2.3% |
| 5 | 1 | 1.1% |
| 6 | 4 | |
| 7 | 3 | 3.4% |
| 8 | 3 | 3.4% |
| 9 | 3 | 3.4% |
| 10 | 3 | 3.4% |
| Value | Count | Frequency (%) |
| 116 | 1 | 1.1% |
| 51 | 1 | 1.1% |
| 48 | 1 | 1.1% |
| 40 | 3 | |
| 39 | 1 | 1.1% |
| 36 | 1 | 1.1% |
| 33 | 1 | 1.1% |
| 32 | 1 | 1.1% |
| 29 | 1 | 1.1% |
| 27 | 1 | 1.1% |
Messaging Conversations Started
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 32 |
|---|---|
| Distinct (%) | 46.4% |
| Missing | 18 |
| Missing (%) | 20.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.10144928 |
| Minimum | 1 |
|---|---|
| Maximum | 121 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 824.0 B |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 9 |
| Q3 | 23 |
| 95-th percentile | 53.2 |
| Maximum | 121 |
| Range | 120 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 20.5477528 |
|---|---|
| Coefficient of variation (CV) | 1.201521138 |
| Kurtosis | 8.878494335 |
| Mean | 17.10144928 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 2.503211861 |
| Sum | 1180 |
| Variance | 422.2101449 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 7 | 8.0% |
| 3 | 6 | 6.9% |
| 2 | 5 | 5.7% |
| 5 | 4 | 4.6% |
| 10 | 4 | 4.6% |
| 8 | 4 | 4.6% |
| 6 | 3 | 3.4% |
| 9 | 3 | 3.4% |
| 17 | 3 | 3.4% |
| 29 | 2 | 2.3% |
| Other values (22) | 28 | |
| (Missing) | 18 |
| Value | Count | Frequency (%) |
| 1 | 7 | |
| 2 | 5 | |
| 3 | 6 | |
| 4 | 2 | 2.3% |
| 5 | 4 | |
| 6 | 3 | |
| 7 | 2 | 2.3% |
| 8 | 4 | |
| 9 | 3 | |
| 10 | 4 |
| Value | Count | Frequency (%) |
| 121 | 1 | |
| 65 | 1 | |
| 64 | 1 | |
| 56 | 1 | |
| 49 | 1 | |
| 43 | 2 | |
| 42 | 1 | |
| 41 | 1 | |
| 38 | 1 | |
| 36 | 2 |
| Distinct | 79 |
|---|---|
| Distinct (%) | 90.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.170927552 |
| Minimum | 0 |
|---|---|
| Maximum | 2.213877 |
| Zeros | 8 |
| Zeros (%) | 9.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 824.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1.090525 |
| median | 1.212693 |
| Q3 | 1.372782 |
| 95-th percentile | 1.7404124 |
| Maximum | 2.213877 |
| Range | 2.213877 |
| Interquartile range (IQR) | 0.282257 |
Descriptive statistics
| Standard deviation | 0.4386805971 |
|---|---|
| Coefficient of variation (CV) | 0.3746436716 |
| Kurtosis | 2.845484436 |
| Mean | 1.170927552 |
| Median Absolute Deviation (MAD) | 0.154365 |
| Skewness | -1.339504037 |
| Sum | 101.870697 |
| Variance | 0.1924406663 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 8 | 9.2% |
| 1 | 2 | 2.3% |
| 1.103567 | 1 | 1.1% |
| 1.416992 | 1 | 1.1% |
| 1.294536 | 1 | 1.1% |
| 1.096291 | 1 | 1.1% |
| 1.27367 | 1 | 1.1% |
| 1.180587 | 1 | 1.1% |
| 1.421704 | 1 | 1.1% |
| 1.188254 | 1 | 1.1% |
| Other values (69) | 69 |
| Value | Count | Frequency (%) |
| 0 | 8 | |
| 1 | 2 | 2.3% |
| 1.006003 | 1 | 1.1% |
| 1.006452 | 1 | 1.1% |
| 1.021429 | 1 | 1.1% |
| 1.022581 | 1 | 1.1% |
| 1.026178 | 1 | 1.1% |
| 1.028681 | 1 | 1.1% |
| 1.033103 | 1 | 1.1% |
| 1.035391 | 1 | 1.1% |
| Value | Count | Frequency (%) |
| 2.213877 | 1 | |
| 2.020319 | 1 | |
| 1.974644 | 1 | |
| 1.76544 | 1 | |
| 1.764329 | 1 | |
| 1.684607 | 1 | |
| 1.644993 | 1 | |
| 1.625648 | 1 | |
| 1.549848 | 1 | |
| 1.548859 | 1 |
| Distinct | 79 |
|---|---|
| Distinct (%) | 90.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.048275046 |
| Minimum | 0 |
|---|---|
| Maximum | 10.7 |
| Zeros | 9 |
| Zeros (%) | 10.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 824.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.337426 |
| median | 0.682813 |
| Q3 | 1.0735725 |
| 95-th percentile | 2.4130448 |
| Maximum | 10.7 |
| Range | 10.7 |
| Interquartile range (IQR) | 0.7361465 |
Descriptive statistics
| Standard deviation | 1.699669893 |
|---|---|
| Coefficient of variation (CV) | 1.621396884 |
| Kurtosis | 20.92144389 |
| Mean | 1.048275046 |
| Median Absolute Deviation (MAD) | 0.366637 |
| Skewness | 4.398133444 |
| Sum | 91.199929 |
| Variance | 2.888877745 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 9 | 10.3% |
| 0.500159 | 1 | 1.1% |
| 1.248699 | 1 | 1.1% |
| 0.830189 | 1 | 1.1% |
| 0.557 | 1 | 1.1% |
| 0.887941 | 1 | 1.1% |
| 1.816979 | 1 | 1.1% |
| 0.3125 | 1 | 1.1% |
| 0.3925 | 1 | 1.1% |
| 0.333279 | 1 | 1.1% |
| Other values (69) | 69 |
| Value | Count | Frequency (%) |
| 0 | 9 | |
| 0.065317 | 1 | 1.1% |
| 0.074238 | 1 | 1.1% |
| 0.113662 | 1 | 1.1% |
| 0.135714 | 1 | 1.1% |
| 0.148368 | 1 | 1.1% |
| 0.166771 | 1 | 1.1% |
| 0.167179 | 1 | 1.1% |
| 0.173624 | 1 | 1.1% |
| 0.275962 | 1 | 1.1% |
| Value | Count | Frequency (%) |
| 10.7 | 1 | |
| 9.620581 | 1 | |
| 7.709 | 1 | |
| 2.74902 | 1 | |
| 2.462105 | 1 | |
| 2.298571 | 1 | |
| 2.005257 | 1 | |
| 1.879412 | 1 | |
| 1.816979 | 1 | |
| 1.743889 | 1 |
| Distinct | 79 |
|---|---|
| Distinct (%) | 90.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.988235609 |
| Minimum | 0 |
|---|---|
| Maximum | 18.461538 |
| Zeros | 9 |
| Zeros (%) | 10.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 824.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2.5359305 |
| median | 4.755245 |
| Q3 | 6.1143855 |
| 95-th percentile | 13.740369 |
| Maximum | 18.461538 |
| Range | 18.461538 |
| Interquartile range (IQR) | 3.578455 |
Descriptive statistics
| Standard deviation | 3.83244521 |
|---|---|
| Coefficient of variation (CV) | 0.7682967507 |
| Kurtosis | 2.798938627 |
| Mean | 4.988235609 |
| Median Absolute Deviation (MAD) | 1.698938 |
| Skewness | 1.435802975 |
| Sum | 433.976498 |
| Variance | 14.68763629 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 9 | 10.3% |
| 3.915475 | 1 | 1.1% |
| 4.238456 | 1 | 1.1% |
| 5.016089 | 1 | 1.1% |
| 5.855563 | 1 | 1.1% |
| 6.017699 | 1 | 1.1% |
| 1.932173 | 1 | 1.1% |
| 10.505581 | 1 | 1.1% |
| 9.52381 | 1 | 1.1% |
| 5.842912 | 1 | 1.1% |
| Other values (69) | 69 |
| Value | Count | Frequency (%) |
| 0 | 9 | |
| 0.255754 | 1 | 1.1% |
| 0.840172 | 1 | 1.1% |
| 1.033592 | 1 | 1.1% |
| 1.217949 | 1 | 1.1% |
| 1.46636 | 1 | 1.1% |
| 1.811137 | 1 | 1.1% |
| 1.932173 | 1 | 1.1% |
| 2.037822 | 1 | 1.1% |
| 2.21412 | 1 | 1.1% |
| Value | Count | Frequency (%) |
| 18.461538 | 1 | |
| 16.734069 | 1 | |
| 16.419001 | 1 | |
| 15.429831 | 1 | |
| 14.894193 | 1 | |
| 11.048113 | 1 | |
| 10.505581 | 1 | |
| 10.055866 | 1 | |
| 9.52381 | 1 | |
| 8.744395 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Campaign ID | Starts | Ends | Ad set budget | Results | Reach | Impressions | Cost per results | Amount spent (MXN) | Result rate | New messaging connections | Messaging Conversations Started | Frequency | CPC (All) (MXN) | CTR (all) | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 341 | 01 | 02 | Using ad set budget | NaN | 0 | 0 | NaN | 0.00 | NaN | NaN | NaN | 0.000000 | 0.000000 | 0.000000 |
| 1 | 995 | 01 | 02 | Using ad set budget | NaN | 0 | 0 | NaN | 0.00 | NaN | NaN | NaN | 0.000000 | 0.000000 | 0.000000 |
| 2 | 964 | 01 | 02 | Using ad set budget | NaN | 0 | 0 | NaN | 0.00 | NaN | NaN | NaN | 0.000000 | 0.000000 | 0.000000 |
| 3 | 849 | 02 | 02 | Using ad set budget | NaN | 0 | 0 | NaN | 0.00 | NaN | NaN | NaN | 0.000000 | 0.000000 | 0.000000 |
| 4 | 182 | 02 | 02 | Using ad set budget | NaN | 0 | 0 | NaN | 0.00 | NaN | NaN | NaN | 0.000000 | 0.000000 | 0.000000 |
| 5 | 663 | 02 | 02 | Using ad set budget | 2.0 | 0 | 0 | 0.000000 | 0.00 | NaN | NaN | 2.0 | 0.000000 | 0.000000 | 0.000000 |
| 6 | 928 | 03 | 03 | Using ad set budget | 15.0 | 2511 | 3072 | 5.560000 | 83.40 | 0.488281 | 9.0 | 15.0 | 1.223417 | 0.538065 | 5.045573 |
| 7 | 264 | 03 | 03 | Using ad set budget | 8.0 | 1408 | 1656 | 7.470000 | 59.76 | 0.483092 | 8.0 | 8.0 | 1.176136 | 0.429928 | 8.393720 |
| 8 | 465 | 03 | 03 | Using ad set budget | 36.0 | 13358 | 17480 | 12.796667 | 460.68 | 0.205950 | 29.0 | 36.0 | 1.308579 | 0.543255 | 4.851259 |
| 9 | 816 | 03 | 04 | Using ad set budget | 17.0 | 4203 | 5906 | 15.742353 | 267.62 | 0.287843 | 13.0 | 17.0 | 1.405187 | 0.803664 | 5.638334 |
Last rows
| Campaign ID | Starts | Ends | Ad set budget | Results | Reach | Impressions | Cost per results | Amount spent (MXN) | Result rate | New messaging connections | Messaging Conversations Started | Frequency | CPC (All) (MXN) | CTR (all) | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77 | 416 | 11 | 11 | 1000 | NaN | 620 | 634 | NaN | 26.49 | NaN | NaN | NaN | 1.022581 | 0.735833 | 5.678233 |
| 78 | 625 | 11 | 11 | 500 | 22.0 | 5454 | 7719 | 22.727273 | 500.00 | 0.285011 | 22.0 | 22.0 | 1.415292 | 0.959693 | 6.749579 |
| 79 | 135 | 11 | 11 | 500 | 30.0 | 7150 | 9205 | 16.666667 | 500.00 | 0.325910 | 26.0 | 30.0 | 1.287413 | 1.016260 | 5.344921 |
| 80 | 869 | 11 | 11 | 160 | NaN | 1120 | 1345 | NaN | 50.25 | NaN | NaN | NaN | 1.200893 | 0.810484 | 4.609665 |
| 81 | 465 | 11 | 11 | 500 | 6.0 | 3657 | 5404 | 57.548333 | 345.29 | 0.111029 | 6.0 | 6.0 | 1.477714 | 1.743889 | 3.663953 |
| 82 | 772 | 11 | 11 | 300 | NaN | 191 | 196 | NaN | 16.57 | NaN | NaN | NaN | 1.026178 | 1.380833 | 6.122449 |
| 83 | 126 | 01 | 01 | 200 | 10.0 | 2435 | 3548 | 16.065000 | 160.65 | 0.281849 | 10.0 | 10.0 | 1.457084 | 0.823846 | 5.496054 |
| 84 | 499 | 01 | 01 | 300 | 8.0 | 2894 | 3970 | 25.201250 | 201.61 | 0.201511 | 8.0 | 8.0 | 1.371804 | 0.908153 | 5.591940 |
| 85 | 548 | 01 | 01 | 300 | 13.0 | 3285 | 3920 | 17.327692 | 225.26 | 0.331633 | NaN | 13.0 | 1.193303 | 2.298571 | 2.500000 |
| 86 | 531 | 03 | 03 | 500 | 26.0 | 8124 | 9842 | 11.015385 | 286.40 | 0.264174 | 21.0 | 26.0 | 1.211472 | 0.569384 | 5.110750 |